UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v+193d9JCttCBoSkDfoYt7EwIcpFQUvlJ8+mh5roYYU='
WHERE
key_id = 'c8f5d8bc9b7f80f243db69842d5aff9225a58d991459fa32e9e213515addca4c'
AND (
token = 'v+193d9JCttCBoSkDfoYt7EwIcpFQUvlJ8+mh5roYYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)