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