UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sSjlAT5vL2huWxw5O6d8N8wQccaB6FsfVM7BV+bVxwE='
WHERE
key_id = 'fdd8df42a7e0eaf720213a1bbf236b4e7a43f0abc3f5b4604d80f414337e85d3'
AND (
token = 'sSjlAT5vL2huWxw5O6d8N8wQccaB6FsfVM7BV+bVxwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)