UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NyoH9QvbhnTPT48dT4ixcuUpBw/4LUWF+We6seXLZLQ='
WHERE
key_id = '9931d1c9d319b7def84474efb06f285a73593596796aeb0ecf469e3f44eadc83'
AND (
token = 'NyoH9QvbhnTPT48dT4ixcuUpBw/4LUWF+We6seXLZLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)