UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QE/JrGkrxgkDYxK7w3JK4AFbvsEUT44pSeljKoPyV/U='
WHERE
key_id = '0ac0a44550e1d182246791139a8953f33c4260ff89374adf89b4ba0060588e40'
AND (
token = 'QE/JrGkrxgkDYxK7w3JK4AFbvsEUT44pSeljKoPyV/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)