UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wy987181OrlINgw32K7wIdTTCvOqilgrSjpqHrIzF9Y='
WHERE
key_id = '7a2a87ca27fd05a08ec65ae544c2d10b86e4c694e27628ca164e5c8338f4d057'
AND (
token = 'wy987181OrlINgw32K7wIdTTCvOqilgrSjpqHrIzF9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)