UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6d9HV0L4t9Y0WuPKok7jaq69TbzYJCoVc04PmyeJCnE='
WHERE
key_id = 'd17f98d043ac3d1da4bccd8e71e8474756811dce72dd178cf08aa06e7fe632b7'
AND (
token = '6d9HV0L4t9Y0WuPKok7jaq69TbzYJCoVc04PmyeJCnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)