UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Bd+y9Wwst5W9BQV8hmKvem/hnYNc8jMHXMhNj7iXjeQ=' 
WHERE 
  key_id = '2a120f65a40da4bca74432696cb3b7353bd657cc424b67768e2265cfcc8f81dc' 
  AND (
    token = 'Bd+y9Wwst5W9BQV8hmKvem/hnYNc8jMHXMhNj7iXjeQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032