UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXD6gaxBzVQNA6vK+RAewtWgqYUnM3P4BLJP3sN/of0='
WHERE
key_id = 'abdd52e35471bf8698dd2df2973ccebe8a8beadf5ca5fdd64bdb30c6fa11592e'
AND (
token = 'xXD6gaxBzVQNA6vK+RAewtWgqYUnM3P4BLJP3sN/of0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)