UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LNmOlB3DLcFfpaQEMTHPfH1mfcXPZvoN/A3Pn0kNwcs='
WHERE
key_id = 'c3be7d227e7df60fc57980b0a5dd21a421d5464b079b645b189a9bea5f762d6b'
AND (
token = 'LNmOlB3DLcFfpaQEMTHPfH1mfcXPZvoN/A3Pn0kNwcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)