UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnkYLzfemCygQ+s4fVeu7k3aAkr1txm8gHaM8jFnQ4A='
WHERE
key_id = '29add63da83c4ea3b9c0f93ed60d02d8c97747c3062e2b2199c2fe4a936c071e'
AND (
token = 'NnkYLzfemCygQ+s4fVeu7k3aAkr1txm8gHaM8jFnQ4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)