UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZwHlVhVaJSPAHbMn0p/MoZ8Ns3uXC1s3QMaC19fLR7A='
WHERE
key_id = 'fa4530269fbdb623a667c7ae9d09ce160a351adf3787cfc61efe0a83b5b987ac'
AND (
token = 'ZwHlVhVaJSPAHbMn0p/MoZ8Ns3uXC1s3QMaC19fLR7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)