UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dH/alFQdTJziX7a2DL3UG0thZkjRhWyLFvgfL15llI0='
WHERE
key_id = 'e7da1b3972ae9a41a2cfa04c1bee4973abe86842eb9198f3ab02ff795fc40023'
AND (
token = 'dH/alFQdTJziX7a2DL3UG0thZkjRhWyLFvgfL15llI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)