UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OTmGxyFJVnJCPzofmeuNPHtydn72dRUpJCYhnN1J9Vg='
WHERE
key_id = '0a23ba4e776c0e9df65f8c7f3bf4fdeabe68203df8e98b2cb3eb0903d3aabcc1'
AND (
token = 'OTmGxyFJVnJCPzofmeuNPHtydn72dRUpJCYhnN1J9Vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)