UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZg+fPJZr8qfzIveGAbCNsJ0BSSmer7GHNVZOz1rwNI='
WHERE
key_id = 'a095379cf3edb5dbf09ad026ea06b1d22ab55be102eb29e6b1c3a36167dc2a1e'
AND (
token = 'PZg+fPJZr8qfzIveGAbCNsJ0BSSmer7GHNVZOz1rwNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)