UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fRb22XZIwwT3DHY92pHmsGJ4fsOGF7RQjWgvUoOzRU='
WHERE
key_id = '6fef1a55d27991d17c21d1297cf71e9a99b3332b0cdff4a96fc4a7e71541eb12'
AND (
token = '1fRb22XZIwwT3DHY92pHmsGJ4fsOGF7RQjWgvUoOzRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)