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