UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pii4DoGz4NlISYIyqOfdIvsUJIn2qhudFSkLgE0xTCA='
WHERE
key_id = '2a5ac4fd8f86af76bf34b4a8e0cb76831916f8234ae52e5a4116ee721d3ebff2'
AND (
token = 'Pii4DoGz4NlISYIyqOfdIvsUJIn2qhudFSkLgE0xTCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)