UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uC7lsRkxoH80aSHogU2YSKwltJg9njRkHy0E28HjxJU='
WHERE
key_id = 'b8010f7a6303355e2db5f562dcc79d4be14abd2f9c9393642b4951b367fb6712'
AND (
token = 'uC7lsRkxoH80aSHogU2YSKwltJg9njRkHy0E28HjxJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)