UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUeXXgVh0DjUlydjm28U5QK891GRMLW+BOGp6jd5+iw='
WHERE
key_id = 'c0ccc5770c932582d4466d9e975b95705e3a256566869caa60465659c08d2d09'
AND (
token = 'ZUeXXgVh0DjUlydjm28U5QK891GRMLW+BOGp6jd5+iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)