UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NqXa6eDSTXnaP3avtx/ZUQ5FGVpnt0nuf5JjX0bvzXE=' 
WHERE 
  key_id = '0070b4251f14dd95610b9dee422d18c946d7530dcfe6b196cecf9f3e1165a6a8' 
  AND (
    token = 'NqXa6eDSTXnaP3avtx/ZUQ5FGVpnt0nuf5JjX0bvzXE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027