UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHF4PdZhVdD+nDhA7A4tQxEak4YR9IcQFvd0h7iE6cw='
WHERE
key_id = '0df8e3ac67848c17678e89ce9afd73288ba18d1b741d140ab373784a92574c01'
AND (
token = 'zHF4PdZhVdD+nDhA7A4tQxEak4YR9IcQFvd0h7iE6cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)