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