UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y9XxWfKORMqdjRwh/mEpxtvlKbWFDH6HKppFbnA93Og='
WHERE
key_id = 'fc26f9a2dd01f75f669dd0d680e59527a1f59877909a92af46fd8a92de51c42a'
AND (
token = 'y9XxWfKORMqdjRwh/mEpxtvlKbWFDH6HKppFbnA93Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)