UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MGJ1r7EhLTxn8oYnCFOrCAq37xSJduJJD1u7TrxYpg='
WHERE
key_id = 'e7895b8bd0cf00fff4ffa8021c9334cc8dd62fbf6cb740f2cbc1f6814769d914'
AND (
token = '9MGJ1r7EhLTxn8oYnCFOrCAq37xSJduJJD1u7TrxYpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)