UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HJ37z/lpwo0evRelCQz6w2Pt6ejSINNrY+xLPQg8LwU='
WHERE
key_id = 'bfccaf8e74cf1fb6dffc9d4db50d169817a75ee4937caa5cbd685a4407d7e2a4'
AND (
token = 'HJ37z/lpwo0evRelCQz6w2Pt6ejSINNrY+xLPQg8LwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)