UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RohqyuYCZQV72mtba0UMlkOMcowD0e4SeE7TlSuqAZw='
WHERE
key_id = 'a14b48f9877e8fe483b47071a84e99230caaa9934fdf5ea486dd75df8ef4c04e'
AND (
token = 'RohqyuYCZQV72mtba0UMlkOMcowD0e4SeE7TlSuqAZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)