UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDrKI86+xT9OqW/FxPiRgIs7WebGWdhO4B/Oov8eoIs='
WHERE
key_id = '9eaff7feefb8dafc85c528d3ce36eeef5cb02e99020711ee08d725c1d3f657ca'
AND (
token = 'HDrKI86+xT9OqW/FxPiRgIs7WebGWdhO4B/Oov8eoIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)