UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BugfLOvPTW0MwUEe0ZeBqCff5b2j23PWifFKHEwfIIs='
WHERE
key_id = '0187b9d2a39d871dc505cbf8e4fc092e46446e2206cd495f4cf16be41cd25a26'
AND (
token = 'BugfLOvPTW0MwUEe0ZeBqCff5b2j23PWifFKHEwfIIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)