UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBpfkBfQK0KGvFCbL65yIZZUPrIfdrbSdhnqxMCSnoM='
WHERE
key_id = 'bdbe2bcadd80016f18796638135a8e8718da0eb9db87dfe52944191c7fe08bae'
AND (
token = 'UBpfkBfQK0KGvFCbL65yIZZUPrIfdrbSdhnqxMCSnoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)