UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgwxFlYaDa9o9fjZtxY1l+XOFERvHWizLnZVPujdDTA='
WHERE
key_id = 'f3b7737e1ddda26945439f0ac61f5ecf241c3f5a6d64afab600804894a62d720'
AND (
token = 'zgwxFlYaDa9o9fjZtxY1l+XOFERvHWizLnZVPujdDTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)