UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hy6knvwdykHmDzyC2ajAIjVOZLqU92KYX5XrXVkEdMw='
WHERE
key_id = 'e7da76aad5ed59a57f9b48ce72d568c44c005fe7b23d877a1aa3d2f2bda00930'
AND (
token = 'hy6knvwdykHmDzyC2ajAIjVOZLqU92KYX5XrXVkEdMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)