UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z23nMJ6pPmmIHyAAZfy2RHzvhHIo6Ou+sldmBtY/a30='
WHERE
key_id = 'f7406da7cdd62f00ebe97a1d0fcebf8415b35fc7afd63e513385a8e3399e1f3e'
AND (
token = 'Z23nMJ6pPmmIHyAAZfy2RHzvhHIo6Ou+sldmBtY/a30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)