UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZ67HwHIXk4PS8bj1clYCw6ujc8WQZdbBQ3++vrxlKA='
WHERE
key_id = '3f9c7d31941a92ff33230431169bcf7ce90b64fa40ea282712ed6e15f300c40c'
AND (
token = 'dZ67HwHIXk4PS8bj1clYCw6ujc8WQZdbBQ3++vrxlKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)