UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'URpf9qEMIuJQVLcU/q1dZdgShrG1hoD7BbFzXjGwas4='
WHERE
key_id = '8aae6d071a800e61ea184b54fa52d8a788ec5c23ecddbd83c961fab1d21e6913'
AND (
token = 'URpf9qEMIuJQVLcU/q1dZdgShrG1hoD7BbFzXjGwas4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)